NEW
Font size
WorksheetsMicrosoft Excel Basics
Total questions: 10
Worksheet time: 3mins
It is where you will find the basic commands such as open, save, print, etc
Quick Access Toolbar
Ribbon
File Menu
Tell me
It is designed to help you quickly find the commands that you need to complete a task
Quick Access Toolbar
Ribbon
File Menu
Tell me
To select an entire column in a worksheet, you should press ________.
CTRL+SPACEBAR
SHIFT+SPACEBAR
CTRL+SHIFT+SPACEBAR
SPACEBAR
These are not to be used in calculations which includes numerical information, such as phone numbers and zip codes
Values
Labels
Cell Address
Relative Referencing
These are numerical pieces of information that will be used for calculations.
Labels
Cell Address
Values
Cell Address
A formula starts with an equal sign (=)
True
False
Maybe
Insufficient information
It returns the number of values of the selected cells
SUM
MAX
MIN
COUNT
If you to select non-consecutive cells, then
Press and hold CTRL while clicking column or row headers
Click and drag across column or row headers
Click the first cell in the range. Drag across the cells and release the mouse button
Press and hold CTRL while clicking the celss
If you to select multiple columns, then
Press and hold CTRL while clicking column or row headers
Click and drag across column or row headers
Click the first cell in the range. Drag across the cells and release the mouse button
Press and hold CTRL while clicking the celss
You use this category when you want to enter a text description containing numbers or special characters
Number
General
Text
Accounting
