Excel Formula Quiz: Test Your Microsoft Excel 2013 Skills

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which operator is used to search for related sites?

inurl:

info:

related: (correct)

cached:

What operator should you use to search for a specific website?

inurl: (correct)

info:

cached:

What does the 'cached:' operator do when used in a search?

Locates a specific site

Provides details of a site

Shows Google's cached version of a site (correct)

Searches for related sites

How do people who own multimedia files with creative common licenses determine usage rights?

They must get permission from the owners to use the media Signup and view all the answers

How can you modify the alignment of text within a cell in Microsoft Excel 2013?

By using the buttons in the Alignment group on the Home tab Signup and view all the answers

Which feature allows you to align cell values with the right bottom borders in Microsoft Excel 2013?

Use the buttons in the Alignment group on the Home tab Signup and view all the answers

What is the purpose of indenting cell text in Microsoft Excel 2013?

To adjust the positioning of text within the cell Signup and view all the answers

What is the function of adding borders of different styles and colors to individual cells or ranges in Microsoft Excel 2013?

To visually separate cells or ranges from surrounding data Signup and view all the answers

What is the advantage of using cell references in Excel functions?

Cell references can be easily edited as needed Signup and view all the answers

Which function is recommended when dealing with data that includes a few extremely large or extremely small values that may skew results?

MEDIAN function Signup and view all the answers

What are the three possible methods for inserting a function in Excel?

Function Library, Function Category, Insert Function Dialog Box Signup and view all the answers

What feature does the Insert Function Dialog Box provide for locating specific functions?

Search feature Signup and view all the answers

What type of cell reference changes when the formula is copied to another group of cells?

Relative reference Signup and view all the answers

How are absolute cell references denoted in Excel formulas?

$B$2 Signup and view all the answers

What do mixed references contain?

Both relative and absolute references Signup and view all the answers

When is it recommended to use absolute references in Excel?

When creating tables of calculated values Signup and view all the answers

What is the purpose of the F4 key in Excel?

To cycle through different types of cell references Signup and view all the answers

What is the default behavior of AutoFill in Excel?

It copies both content and formatting of the original range to the selected range Signup and view all the answers

When would you use the Auto Fill Options button in Excel?

To specify what is copied during AutoFill Signup and view all the answers

What does the TODAY function do in Excel?

Displays only the current date Signup and view all the answers

In Microsoft Excel, where can you find the options to add a background image to a worksheet?

Page Layout tab Signup and view all the answers

What is the primary purpose of using functions and formulas in Microsoft Excel?

To perform mathematical and statistical calculations Signup and view all the answers

In Tutorial 2 of New Perspectives on Microsoft Excel 2013, what is the purpose of the 'Net Profit/Loss' formula?

To calculate the difference between income and cost of sales Signup and view all the answers

What is the goal of formatting numbers in Microsoft Excel?

To make the workbook easier to interpret Signup and view all the answers

Which type of number format in Excel lines up currency values within a column by currency symbol and decimal point?

Accounting style Signup and view all the answers

How are dates/times stored in Microsoft Excel?

As numbers, not as text Signup and view all the answers

Where can you find the option to select different formats for dates and times in Microsoft Excel worksheets?

Home tab Signup and view all the answers

What is the purpose of using functions in Microsoft Excel?

To perform mathematical and statistical calculations Signup and view all the answers

What does the 'Cost of Sales' formula calculate in Tutorial 2 of New Perspectives on Microsoft Excel 2013?

The cost of producing the store’s menu items Signup and view all the answers

What is the purpose of applying number formats in Microsoft Excel?

To make numbers easier to interpret Signup and view all the answers

How are dates/times affected when different formats are applied in Microsoft Excel?

They remain unaffected by different formats Signup and view all the answers

What is the preferred tab to select the number formats for dates and times in Microsoft Excel?

Home tab Signup and view all the answers

Study Notes

Search Operators

The related: operator is used to search for related sites.
The site: operator is used to search for a specific website.

Search Operators and File Licenses

The cached: operator displays the cached version of a webpage.
Creative Commons licenses determine usage rights for multimedia files.

Microsoft Excel 2013

Cell Alignment and Formatting

Text alignment within a cell can be modified using the Alignment group in the Home tab.
The Right feature allows aligning cell values with the right bottom borders.
Indenting cell text helps to improve readability.
Adding borders of different styles and colors to individual cells or ranges enhances visual appeal.

Functions and Formulas

Using cell references in Excel functions provides flexibility and accuracy.
The TRIMMEAN function is recommended for data with extremely large or small values.
There are three methods for inserting a function: typing it manually, using the Insert Function Dialog Box, or using the AutoSum feature.
The Insert Function Dialog Box helps locate specific functions.
Relative cell references change when the formula is copied to another group of cells.
Absolute cell references are denoted by a $ symbol and do not change when the formula is copied.
Mixed references contain both relative and absolute components.
Absolute references are recommended when the referenced cells should not change.
The F4 key toggles between relative and absolute references.
AutoFill's default behavior is to copy formulas and adjust references.
The Auto Fill Options button provides additional options for filling data.

Date and Time Functions

The TODAY function returns the current date.
The background image option is located in the Page Layout tab.

Functions and Formulas Purpose

The primary purpose of using functions and formulas is to perform calculations and analyze data.
In Tutorial 2 of New Perspectives on Microsoft Excel 2013, the 'Net Profit/Loss' formula calculates profit or loss.

Number Formatting

The primary purpose of formatting numbers is to improve readability and understanding.
The Currency number format lines up currency values within a column by currency symbol and decimal point.
Dates and times are stored as numerical values in Microsoft Excel.
Date and time formats can be selected in the Number group of the Home tab.
Applying number formats helps to improve readability.
Different formats affect dates and times in Microsoft Excel.
The Number tab is the preferred tab for selecting number formats for dates and times.

Purpose of Functions and Formulas

The purpose of using functions in Microsoft Excel is to perform calculations and analyze data.
The 'Cost of Sales' formula calculates the cost of goods sold.
Applying number formats helps to improve readability.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge of formatting worksheet cells in Microsoft Excel 2013. Questions cover topics such as modifying text alignment, indenting cell text, and adding borders with different styles and colors to individual cells or ranges.

Microsoft Excel 2013 Cell Formatting Quiz

Choose a study mode