NEW
Font size
S
M
L
XL
WorksheetsExcel Basics
Total questions: 29
Worksheet time: 58mins
Name
Class
Date
1.
Keyboards can be used to
a)
Move data
b)
challenge data
c)
navigate data
d)
Enter Data
2.
In Excel the rows represent the horizontal cells
a)
Spreadsheets
b)
Letters
c)
Numbers
d)
Characters
3.
_____________ is the helpful key that allows one to deletes the space directly behind the cursor in the active cell each time the key is pressed.
a)
Delete Key
b)
Tab Key
c)
Backspace Key
d)
All Keys
4.
Spreadsheets are grids of rows and columns in which text, numbers and the results of ______________________ can be entered
a)
Files
b)
Worksheets
c)
Calculations
d)
Characters
5.
Export contains the commands for creating a
a)
Email
b)
Cloud Service
c)
Power BI
d)
PDF/XPS
6.
Are saved as _____________ depending on the application used to create, save and open the file
a)
Any change
b)
Different file types
c)
Files
d)
File names
7.
File Tab/Backstage View has the option to exit a program, which is called
a)
Close
b)
Publishing
c)
Exit
d)
File It
8.
Microsoft® Excel can be opened by:
a)
Open
b)
double-clicking on page setup
c)
clicking on the program icon on the start menu
d)
None of the Above
9.
Worksheets can also be called
a)
Spreadsheets
b)
Charts
c)
Templates Protect
10.
________________ Cosists of commands for viewing and printing gridlines and headings
a)
Sheet Options
b)
Arrange
c)
Defined Names
d)
Calculations
11.
Spreadsheets are grids of _________________________ in which text, numbers can be entered.
a)
Rows Only
b)
Rows and columns
c)
Columns only
d)
None of the Above
12.
Insert tab contains the following groups:
a)
Clipboard, Font, Alignment
b)
Tables, Illustrations, Charts, Sparklines
c)
Power BI, Process, Page Setup
d)
None of the Above
13.
Export contains the commands for changing the
a)
Process
b)
PDF
c)
File Type
d)
XPS
14.
Backspace key is the helpful key that allows one to deletes the space directly behind the cursor in the active cell each
time the key is pressed.
a)
Delete Key
b)
Tab Key
c)
Backspace Key
d)
All Keys
15.
Window Group on the View Tab Contains commands to:
- open the _____________ in a new window
a)
Scroll Through
b)
Same workbook
c)
Page Breaks
d)
None of the Above
16.
______________consists of commands which can be used to position objects, open the selection pane, align objects, group
objects and rotate objects.
a)
Sheet Options
b)
Tables
c)
Sparklines
d)
Arrange
17.
____________________ holds commands to zoom in to the worksheet
a)
Sheet Options
b)
Zoom
c)
analyze
d)
Data
18.
Worksheets are ___________________ worksheets
a)
Computerized
b)
Manual
c)
Unusual
d)
Straight
19.
Home tab contains the following groups:
a)
Page set up, Scale to Fit, Text
b)
Text, Sparklines, Tables
c)
Clipboard, Font, Alignment
d)
None of the Above
20.
_______________holds commands to change how the worksheet is shown on
the screen.
a)
Zoom
b)
Window
c)
Worksheet Views
d)
None of the Above
21.
Keyboards can be used to
a)
Move data
b)
challenge data
c)
navigate data
d)
Navigate worksheets
22.
Active Cell is a cell which is currently selected in an Excel spreadsheet; can be identified by a _____________ located around the cell
a)
Heavy red boarder
b)
Heavy green border
c)
Heavy blue border
d)
None of the Above
23.
Keyboard Shortcuts are _____________ which perform certain commands when pressed
a)
Commands
b)
Shortcut Keys
c)
Key Combinations
d)
None of the Above
24.
This keyboard shortcut close a workbook
a)
Control W
b)
Control B
c)
Control S
d)
Control G
25.
Microsoft Excel is a computer program used to do all of the following except:
a)
Process
b)
enter data
c)
analyze
d)
create spreadsheets
26.
These extensions indicate what file type the document is these are called:
a)
General Files
b)
File extensions
c)
Extensions
d)
None of the Above
27.
Common file typs include:
a)
xlsx., doc., text.
b)
.cad,.xls, .pdf
c)
.xlsx, .doc, .xls, .csv
d)
None of the Above
28.
Emailing can be completed by utilizing the _____________ in Backstage View contains options for sharing the workbook including.
a)
Share option
b)
Worksheets
c)
Workbook
d)
None of the Above
29.
This keyboard shortcut close a workbook
a)
Control W
b)
Control I
c)
Control S
d)
Control G
Reset
