Microsoft Excel 2013 Cell Formatting Quiz

SuaveJackalope avatar
SuaveJackalope
·
·
Download

Start Quiz

Study Flashcards

32 Questions

Which operator is used to search for related sites?

related:

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

inurl:

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

Shows Google's cached version of a site

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

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

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

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

To adjust the positioning of text within the cell

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

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

Cell references can be easily edited as needed

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

MEDIAN function

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

Function Library, Function Category, Insert Function Dialog Box

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

Search feature

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

Relative reference

How are absolute cell references denoted in Excel formulas?

$B$2

What do mixed references contain?

Both relative and absolute references

When is it recommended to use absolute references in Excel?

When creating tables of calculated values

What is the purpose of the F4 key in Excel?

To cycle through different types of cell references

What is the default behavior of AutoFill in Excel?

It copies both content and formatting of the original range to the selected range

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

To specify what is copied during AutoFill

What does the TODAY function do in Excel?

Displays only the current date

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

Page Layout tab

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

To perform mathematical and statistical calculations

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

What is the goal of formatting numbers in Microsoft Excel?

To make the workbook easier to interpret

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

Accounting style

How are dates/times stored in Microsoft Excel?

As numbers, not as text

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

Home tab

What is the purpose of using functions in Microsoft Excel?

To perform mathematical and statistical calculations

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

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

To make numbers easier to interpret

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

They remain unaffected by different formats

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

Home tab

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.

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.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free

More Quizzes Like This

Master Microsoft Excel
5 questions
Microsoft Excel
5 questions

Microsoft Excel

SpellboundSmokyQuartz avatar
SpellboundSmokyQuartz
Microsoft Excel Features Quiz
0 questions
Use Quizgecko on...
Browser
Browser