CramX
RegisterLog in

Excel Crash Course Exam With Answers (36 Solved Questions)

Excel Crash Course Exam With Answers gives you access to high-quality past exams for thorough preparation.

Anna Wilson
Contributor
4.3
42
7 months ago
Preview (4 of 11 Pages)
100%
Purchase to unlock

Page 1

Excel Crash Course Exam With Answers (36 Solved Questions) - Page 1 preview image

Loading page ...

Excel Crash Course/36 Questions With CompleteSolution Rated (A+)Quiz :All of the following are keyboard shortcut that allow the user input toadd more sheets to a workbook EXCEPT:Alt i wAlt h i sShift F11Alt Shift F1Alt h i wIncorrect-Answer :Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboardshortcuts for adding more sheets to a workbook.Alt h i w is not a valid shortcut.Quiz :What is a keyboard shortcut to open a file?Ctrl oCtrl fAlt oCtrl n-Answer :The correct answer is Ctrl o.Ctrl f is the shortcut to find, or find and replace, text on the worksheet. Alt o isnot a command. Ctrl n is the shortcut to open a new workbook.Quiz :What is the recommended workbook calculation setting for Excel?AutomaticManualAutomatic except for Data TablesIterate-Answer :The correct answer is "Automatic except for Data Tables".Data tables can significantly slow down Excel and other programs."Automatic", the default setting, will automatically calculate everything in theworkbook, including data tables, which will make the program run moreslowly. The Manual setting will requirethe user to frequently recalculate theworkbook in order to display correctly. "Iterate" is not a setting for workbookcalculation in Excel; iterative calculation is a toggle for users to set forworkbooks that may have circular calculations.qQuiz :Toadd a cell reference from a different worksheet into an existingformula with your keyboard, you should follow the following steps:1. Hit F2 to get into the existing formula; delete any incorrect formulas oroperators 2. Hit F2 again to enable "Enter" mode on the bottom-left corner ofthe Excel sheet 3. Holding down Ctrl, use PageUp or PageDown to find the

Page 2

Page 3

Page 4

Preview Mode

This document has 11 pages. Sign in to access the full document!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Subject
Information Technology

Related Documents

View all
Class Notes

DevOps and Its Importance Study Notes

DevOps Overview – Covers culture, performance metrics, CI/CD, CALMS model, automation, continuous testing, and frameworks like Agile, SAFe, and SRE. Ideal for modern IT and DevOps foundation learning.

Past Exams

Veeam Certified Engineer VMCE-V12

Veeam Backup Q&A – Covers Scale-out Backup Repositories, Oracle RMAN plug-in, agent-supported OS, and retention policies. Ideal for IT pros preparing for Veeam certification or data protection roles.

Past Exams

Modules 1 - 3 Basic Network Connectivity and Commu

Modules 1–3: ITN v7.0 Exam Answers on Basic Network Connectivity and Communications. Covers OSI model, IP addressing, protocols, and network devices. Ideal for CCNA exam prep.

Class Notes

Notes CCNA

Set boot file and recover from crash on Cisco switches. Use boot system commands, mode button, and boot loader steps to restore functionality after power loss or software issues.

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 20

Configure and secure NTP for accurate time across your network. Learn NTP design, troubleshooting, clock settings, and timestamps with configuration examples to support SLAs and log accuracy.

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 22

Manage traffic using ACLs: Learn to create, apply, and verify standard, extended, named, and IPv6 ACLs. Includes tips, keywords, sequence numbers, and configuration examples.

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 36

Learn how to subnet IPv4 addresses using binary math, including Class B and C subnetting, binary ANDing, and shortcuts—essential skills for mastering the CCNA 200-301 exam.

Class Notes

Foundations of Novell Networking Section 26

Learn how web servers work and explore installing and configuring the NetWare Enterprise Web Server in NetWare 6, including support for iFolder and iPrint.

Class Presentation

Modulo 7 DHCPv4

Aprende a configurar DHCPv4 para asignar IPs dinámicamente. Ideal para redes grandes o pequeñas, usando servidores dedicados o routers Cisco con IOS como servidor DHCP eficiente.

Class Notes

Build and troubleshooting Integration Challenge

Networking Practice Exam: Configura y soluciona redes con routers y VLANs. Incluye direccionamiento IP detallado, subredes, interfaces y pruebas de conectividad para integración de sistemas.