Excel using : Workbook • Worksheet • Column • Row • Cell • Range • Formula • Function • Sum function • Copy formulas / functions using the Fill Handle • Basic graphs • Display formulas (Ctrl + `) • Formatting o Bold, italic, underline, color, fill color, alignment. o Number formatting: comma, percent, currency o Increase/decrease the number of decimal places o Merge and center o Add borders • Styles and Themes • Ribbon • Tabs

What is the default name of the first worksheet in an Excel workbook?
Sheet1
Worksheet1
FirstSheet
PrimarySheet
Which of the following is used to organize data vertically in Excel?
Column
Row
Cell
Range
How many cells are there in a single row of an Excel worksheet?
256
512
1024
16384
Which of the following is used to organize data horizontally in Excel?
Row
Column
Cell
Range
What is the intersection of a column and a row in Excel called?
Cell
Range
Worksheet
Workbook
Which of the following allows you to select multiple cells in Excel?
Ctrl + Click
Shift + Click
Alt + Click
Right Click
What is the function used to add up a range of cells in Excel?
Sum
Average
Count
Max
How can you copy formulas or functions to adjacent cells using the Fill Handle in Excel?
Click and drag the Fill Handle
Right-click and select Copy
Press Ctrl + C, then Ctrl + V
Double-click the Fill Handle
Which of the following is not a basic graph type in Excel?
Line
Bar
Pie
Scatter
How can you display formulas instead of their results in Excel?
Ctrl + `
Ctrl + F
Ctrl + H
Ctrl + P
How can you make text bold in Excel?
Ctrl + B
Ctrl + U
Ctrl + I
Ctrl + S
Which formatting option allows you to merge multiple cells into one in Excel?
Merge and Center
Bold
Italic
Underline
How can you add borders to cells in Excel?
Home tab > Font group > Borders button
Insert tab > Borders group > Border button
Page Layout tab > Page Setup group > Borders button
Formulas tab > Function Library group > Borders button
Which of the following is not a number formatting option in Excel?
Comma
Percent
Currency
Merge and Center
How can you increase or decrease the number of decimal places in Excel?
Home tab > Number group > Increase Decimal or Decrease Decimal buttons
Insert tab > Number group > Increase Decimal or Decrease Decimal buttons
Page Layout tab > Page Setup group > Increase Decimal or Decrease Decimal buttons
Formulas tab > Function Library group > Increase Decimal or Decrease Decimal buttons
What is the term for a collection of formatting options applied to a worksheet in Excel?
Style
Theme
Format
Template
Which part of the Excel window contains tabs that group related commands together?
Ribbon
Worksheet
Workbook
Cell
How can you access different tabs in the Ribbon in Excel?
Click on the tab name
Press Alt + the underlined letter of the tab name
Right-click and select the tab name
Double-click on the tab name
Which of the following is not a valid name for an Excel worksheet?
Sheet1
DataSheet
Sales Report
PrimarySheet
What is the maximum number of worksheets you can have in an Excel workbook?
50
100
255
Unlimited
How can you insert a new worksheet in an Excel workbook?
Home tab > Cells group > Insert button
Insert tab > Cells group > Insert button
Page Layout tab > Page Setup group > Insert button
Formulas tab > Function Library group > Insert button
How can you delete a worksheet in an Excel workbook?
Right-click on the worksheet tab and select Delete
Home tab > Cells group > Delete button
Insert tab > Cells group > Delete button
Page Layout tab > Page Setup group > Delete button
What is the keyboard shortcut to save an Excel workbook?
Ctrl + S
Ctrl + C
Ctrl + V
Ctrl + P
How can you change the font color of text in Excel?
Home tab > Font group > Font Color button
Insert tab > Font group > Font Color button
Page Layout tab > Page Setup group > Font Color button
Formulas tab > Function Library group > Font Color button
Which formatting option allows you to align text in cells in Excel?
Alignment
Bold
Italic
Underline
How can you apply a fill color to cells in Excel?
Home tab > Font group > Fill Color button
Insert tab > Font group > Fill Color button
Page Layout tab > Page Setup group > Fill Color button
Formulas tab > Function Library group > Fill Color button
How can you apply a border to cells in Excel?
Home tab > Font group > Borders button
Insert tab > Borders group > Border button
Page Layout tab > Page Setup group > Borders button
Formulas tab > Function Library group > Borders button
What is the purpose of using styles in Excel?
To apply consistent formatting to cells
To create charts and graphs
To perform calculations
To sort data
Which of the following is not a valid theme in Excel?
Office
Apex
Clarity
Rainbow
How can you rename a worksheet in an Excel workbook?
Double-click on the worksheet tab and type the new name
Right-click on the worksheet tab and select Rename
Home tab > Cells group > Rename button
Insert tab > Cells group > Rename button
{"name":"Excel using : Workbook • Worksheet • Column • Row • Cell • Range • Formula • Function • Sum function • Copy formulas \/ functions using the Fill Handle • Basic graphs • Display formulas (Ctrl + `) • Formatting o Bold, italic, underline, color, fill color, alignment. o Number formatting: comma, percent, currency o Increase\/decrease the number of decimal places o Merge and center o Add borders • Styles and Themes • Ribbon • Tabs", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the default name of the first worksheet in an Excel workbook?, Which of the following is used to organize data vertically in Excel?, How many cells are there in a single row of an Excel worksheet?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Make your own Survey
- it's free to start.