Excel using Workbook • Worksheet • Column • Row • Cell • Range • Formula • Fun<wbr>ction • Sum fun<wbr>ction • Copy formulas / fun<wbr>ctions 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 | Take the Quiz

What is a worksheet in Excel?

A single page within an Excel file where you can enter and manipulate data (3 points)

A function used to calculate the sum of a range of cells (0 points)

A formatting option to change the appearance of cells (0 points)

How do you refer to a vertical arrangement of cells in Excel?

Column (3 points)

Row (0 points)

Range (0 points)

What is a cell in Excel?

The intersection of a row and a column, where you can enter data or formulas (3 points)

A predefined formula that performs a specific calculation (0 points)

A formatting option to change the appearance of text (0 points)

Which function in Excel allows you to perform calculations using mathematical operations?

Formula (3 points)

Function (0 points)

Sum function (0 points)

How can you quickly copy formulas or functions to adjacent cells in Excel?

By using the Fill Handle (3 points)

By selecting the cells and pressing Ctrl + ` (0 points)

By applying a predefined style or theme (0 points)

What type of graphs can you create in Excel?

Basic graphs (3 points)

Displayed formulas (0 points)

Increased/decreased decimal places (0 points)

Which shortcut key combination displays all the formulas in an Excel worksheet?

Ctrl + ` (3 points)

Merge and center (0 points)

Add borders (0 points)

How can you format text in Excel to make it bold, italic, or underlined?

Using the formatting options in the Ribbon (3 points)

Increasing/decreasing the number of decimal places (0 points)

Applying a predefined style or theme (0 points)

What formatting option in Excel allows you to change the appearance of numbers as comma-separated values?

Number formatting: comma (3 points)

Merge and center (0 points)

Add borders (0 points)

How can you merge multiple cells into a single cell and center the content in Excel?

Using the Merge and Center option (3 points)

Displaying formulas using Ctrl + ` (0 points)

Adding borders to cells (0 points)

Which feature in Excel allows you to add borders around cells or ranges?

Add borders (3 points)

Styles and Themes (0 points)

Ribbon (0 points)

What is the name given to the collection of tabs in the Excel interface?

Ribbon (3 points)

Tabs (0 points)

Styles and Themes (0 points)

What is a workbook in Excel?

A file that contains one or more worksheets (3 points)

A function used to calculate the sum of a range of cells (0 points)

A formatting option to change the appearance of cells (0 points)

How do you refer to a horizontal arrangement of cells in Excel?

Row (3 points)

Column (0 points)

Range (0 points)

What is a range in Excel?

A group of selected cells (3 points)

A predefined formula that performs a specific calculation (0 points)

A formatting option to change the appearance of text (0 points)

Which function in Excel allows you to perform calculations using mathematical operations?

Formula (3 points)

Function (0 points)

Sum function (0 points)

How can you quickly copy formulas or functions to adjacent cells in Excel?

By using the Fill Handle (3 points)

By selecting the cells and pressing Ctrl + ` (0 points)

By applying a predefined style or theme (0 points)

What type of graphs can you create in Excel?

Basic graphs (3 points)

Displayed formulas (0 points)

Increased/decreased decimal places (0 points)

Which shortcut key combination displays all the formulas in an Excel worksheet?

Ctrl + ` (3 points)

Merge and center (0 points)

Add borders (0 points)

How can you format text in Excel to make it bold, italic, or underlined?

Using the formatting options in the Ribbon (3 points)

Increasing/decreasing the number of decimal places (0 points)

Applying a predefined style or theme (0 points)

Unlock and Upgrade

Remove all limits from your Quizzes

More Quizzes