Which of the following commands is used to insert a cell into a worksheet?

The Insert command in the Cells group on the Home tab.

The Format command in the Cells group on the Home tab

The Format Painter command in the Clipboard group on the Home tab

The Format command in the shortcut menu when you right-click a cell

You don't like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

Apply another style to the cell.

Apply the Normal style to the cell.

Which of the following statements describes how to increase or decrease a column's width?

Drag the boundary next to the column heading

Right-Click anywhere in the column and select format cells

Select a Width setting in the Scale to Fit group on the Page layout tab.

Which of the following statements describes how to unhide a hidden row or column?

Select the rows/columns before and after the hidden rows/columns and the right-click and select Unhide.

Select a range of cells in the row or column, right-click, and select Unhide.

In which of the following locations are check boxes that you can select to view or print gridlines?

On the Page Layout tab, in the Sheet Options group

On the home tab, in the Cells group

On the Page Layout tab, in the Page Setup group

Which of the following procedures is NOT a way to delete one or more worksheets from a workbook?

Press Ctrl+A to select all cells in the worksheet and then press Delete.

Right-click a worksheet tab and click Delete

Click the Delete drop-down arrow on the home tab and click the Delete Sheet.

Select a group of worksheets, right-click the group, and click Delete.

Which of following statements about hidden and unhidden worksheets is correct?

Excel creates a minimized window for each hidden worksheet.

Unhidden worksheets cannot contain formulas that refer to hidden worksheets.

When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.

A hidden worksheet cannot be inadvertently deleted.

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

It lets you reuse formats and formulas in a new sheet.

It's the easiest way to make a backup before making changes.

It helps Excel learn where your data ranges are located.

You should keep one worksheet hidden in case of an error.

Which of the following statements describes how to change the color of a worksheet tab?

Right-click the tab and select Tab Color.

On the Page Layout tab, in the Themes group, select Colors.

Use the Fill Color tool on the Home tab.

you cannot change the color of a worksheet tab.

Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?

Right-click the worksheet's tab and click Hide.

On the view tab, in the Window group, click Hide.

Select the visible area of the worksheet.

Enter the name of the worksheet in the Hide dialog box.

Which of the following steps is NOT a method for inserting a worksheet into a workbook?

On the Insert tab, click Worksheet.

Click on the New sheet (+) button to the right of the worksheet tabs.

On the home tab, click Insert and then click Insert Sheet.

Right-click a worksheet tab and click Insert, then click Worksheet and click OK.

In order for you to freeze the first column of a worksheet into a frozen pane:

You can click Freeze First Column in the Freeze Panes menu.

All the data in the column must be visible.

The first row of the column must be non-blank.

Duplicate worksheets must also be able to have their first columns frozen.

MOS Excel Quiz 2

Authored by Lorri Arnce

Business

9th - 12th Grade

Used 45+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

39 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

AVERAGE

AutoSum

COUNT

MAX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

MIN

AVERAGE

COUNT

MAX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

SUM

COUNTA

MIN

MAX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following statements accurately describes the default selection for AutoSum?

You must first make the selection before clicking AutoSum.

By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.

By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.

AutoSum does not have a default selection.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The COUNT and MIN functions are examples of which category of functions?

Text

Statistical

Financial

Logical

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The AVERAGE function returns the mean value in a range of selected cells.

True

False

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The COUNT function returns the total number of cells in the selected range that contain both text and numbers.

True

False

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

PBMF Chapter 1

Quiz

•

9th - 11th Grade

43 questions

Quarterly Exam

Quiz

•

12th Grade

35 questions

Topic 8 - Taxes and Spending

Quiz

•

12th Grade

34 questions

Business Management- Chapter 8 Test

Quiz

•

9th - 12th Grade

40 questions

Grade 10- Review - Check point 3

Quiz

•

9th Grade

36 questions

Starting a Business, Unit Test REVIEW

Quiz

•

9th - 12th Grade

40 questions

Workplace Communication

Quiz

•

9th - 12th Grade

41 questions

AQA Business Year 1

Quiz

•

12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

10 questions

Probability Practice

Quiz

•

4th Grade

15 questions

Probability on Number LIne

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

6 questions

Appropriate Chromebook Usage

Lesson

•

7th Grade

10 questions

Greek Bases tele and phon

Quiz

•

6th - 8th Grade

Discover more resources for Business

25 questions

Job Interview Skills

Quiz

•

9th - 12th Grade

42 questions

Small Business Types and Opportunities: ESB Review

Quiz

•

10th Grade

MOS Excel Quiz 2

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

Which of the following statements accurately describes the default selection for AutoSum?

The COUNT and MIN functions are examples of which category of functions?

The AVERAGE function returns the mean value in a range of selected cells.

The COUNT function returns the total number of cells in the selected range that contain both text and numbers.

The MAX function returns the total of all cells in the selected range of cells.

The MIN function returns the smallest value in a range of cells.

You must use the AutoSum button to enter a SUM function - you cannot type it manually in a cell.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business