NEW
Font size
WorksheetsExcel Skills Quiz Part 1 and 2
Total questions: 50
Worksheet time: 25mins
What is Microsoft Excel primarily used for?
Image editing
Creating databases
Organizing, analyzing, and calculating data
Video rendering
Each Excel file is called a:
Spreadsheet
Workbook
Worksheet
Document
The intersection of a row and a column in Excel is called a:
Box
Field
Cell
Range
Which tab in Excel contains the *Insert Function* option?
Data
Home
Formulas
View
What is the first step in creating a new workbook?
Click “New” from the File menu
Type data in any cell
Close existing files
Right-click on the desktop
What is the default alignment for text data in Excel?
Right
Center
Left
Justify
What does the AutoFit function do?
Changes font color
Adjusts column width and row height automatically
Deletes empty cells
Centers cell text
What does the *Home* tab mainly contain?
Clipboard, Font, Alignment, Number, Styles
Insert, Chart, SmartArt
Layout and Design
Macros and Code Tools
What key do you press to move from one cell to the next to the right?
Enter
Tab
Shift
Space
To select an entire row, you click:
On the row number
On any cell in that row
On the column header
On the left margin
To insert a new row, you should:
Press Ctrl + Enter
Click Insert under the Home tab
Right-click and choose Delete
Use the View menu
To delete a column, you go to:
File > Delete
Insert tab > Remove Column
Home tab > Cells group > Delete
View tab > Column Options
The command *Find & Select* is found under which tab?
Home
Data
Insert
Formulas
Which feature adds effects such as shadows and glow to shapes?
Effects Tool
SmartArt
Shape Format
Object Designer
What does SmartArt allow you to do?
Create formulas
Add hyperlinks
Visually organize information
Merge cells
To insert a picture from your computer:
Data → Picture
Insert → Picture
Review → Picture
Layout → Picture
To merge multiple cells into one, use:
Format Painter
Merge & Center
Wrap Text
Combine Function
Which alignment centers text vertically between top and bottom of the cell?
Top Align
Center
Middle Align
Align Text Right
A workbook may contain multiple:
Rows
Worksheets
Columns
Functions
The shortcut to Undo in Excel is:
Ctrl + X
Ctrl + Y
Ctrl + Z
Ctrl + D
Which tab is used to rename worksheet tabs?
View
Home
Insert
Page Layout
A workbook can contain ________ worksheets.
Only one
Maximum of 3
Unlimited number
Two by default
Which tab allows you to add charts or illustrations?
Insert
Data
Formulas
Review
To color worksheet tabs:
Click View → Tab Color
Home → Format → Tab Color
Data → Sheet Properties
Review → Color
A spreadsheet cell reference “B3” refers to:
Row 3, Column B
Row B, Column 3
Cell number 3
Third workbook
All formulas in Excel begin with which symbol?
+
-
=
*
Which of the following is a built-in Excel function?
ADD
COMBINE
SUM
APPEND
What does the “IF” function do?
Creates random numbers
Tests a condition and returns TRUE or FALSE outcomes
Sorts numerical data
Hides unwanted rows
The syntax for an IF function is:
IF(value, test, result)
IF(logical_test, value_if_true, value_if_false)
IF(value1=value2, true,false)
IF(condition,true,value)
What will the formula =IF(E11>=40,"Pass","Fail") return if E11=55?
Pass
Fail
Error
55
Which function finds the smallest number in a range?
AVERAGE
MAX
MIN
COUNT
Which function counts the number of numeric entries?
SUM
COUNT
COUNTA
MAX
The Nested IF statement allows you to:
Merge cells
Use multiple conditions in one formula
Add columns
Hide data
What is the function of VLOOKUP in Excel?
Search vertically within a table
Search horizontally within a table
Sort data
Count values
The “!’’ symbol in a formula indicates:
An error
A reference to another worksheet
A comment
A formatting code
To prevent invalid data entry, you use:
Data Sorting
Data Validation
Conditional Formatting
Data Linking
Which feature changes cell appearance based on a condition?
Data Validation
Conditional Formatting
AutoSum
Sorting
To make a reference absolute, use:
Parentheses ( )
Exclamation mark !
Dollar sign $
Comma ,
What does the formula =$A$1+$B$1 represent?
Absolute referencing
Relative referencing
Circular reference
Conditional reference
Which Excel function is used to find the largest number in a range?
SUM
MAX
LARGE
AVERAGE
Which of the following creates a chart?
Home → Chart
Insert → Chart
Page Layout → Chart
Data → Chart
To move a chart to another sheet:
Cut and Paste
Drag with mouse
Use the “Move Chart” option on the Design tab
Use Ctrl + X
Which Excel tab contains the Function Library?
Insert
Formulas
Data
Review
Conditional Formatting is useful for:
Protecting cells
Highlighting trends or unusual values
Linking worksheets
Calculating totals
The Chart Tools tab appears when you:
Click on a chart
Insert a table
Enter a formula
Open Excel
What is the purpose of linking worksheets?
To copy all sheets
To reference data between different sheets
To secure workbook access
To color-code cells
To print only a selected range, you use:
Data → Print
Page Layout → Print Area → Set Print Area
Review → Print Setup
Insert → Page Setup
Which key combination refreshes formula results in Excel?
Ctrl + Shift + R
F9
Ctrl + F5
Shift + Enter
Data Validation is mainly used to:
Add color to data
Restrict invalid input
Protect workbook
Insert comments
Conditional formatting allows Excel to:
Hide formulas
Change styles based on cell values
Merge data sets
Delete duplicates automatically
