Business Info Management - 1st - Part 1

Why would you want to use the freeze row/column feature if you are creating a large database?

• to be able to confuse the meaning of the data

• to be able to calculate the data efficiently

• to be able to not know the category of the data

• to be able to reference the categories of data throughout the spreadsheet

Whether you use a digital pen, touchscreen, or mouse, what feature helps you add notes, create shapes, edit text, and more in Microsoft Office?

• the animation feature

• the draw tab feature

• the smart graphics feature

• the insert chart feature

What is a library of modern, professional graphics, included in Microsoft Word, Excel, and Power-point,  that can be customized to fit your needs?

• geometric shapes

• formulas

• ClipArt

• Icons

When inserting a table into a data-filled spreadsheet, what do the drop down arrows, located in the header row, allow you to do with the data?

• filter the data

• add function to the data

• add additional rows to the data

• change the color of the cell

What function, in Excel, serves as a huge time-saver when you are trying to locate information that needs correction?

• sorting

• AutoSum

• freezing rows and columns

• find and replace

According to this invoice, what did the function, in Cell D7, provide the customer?

• It provided them a 7.5% tax rate.

• It provided them free shipping if their order was equal to or over $100.

• It provided them descriptions of the items purchased.

• It provided them an exact total.

Answer explanation

This function, =IF(D6>=100,0,$G$3), provided the customer free shipping if the total invoice was equal to or greater than $100.

What function can help in this scenario?

 The sales of XYZ Company is increasing the the process of looking up the product name and price from the products worksheet, after adding the product ID.  Can you figure out a way to have the spreadsheet pull this information automatically?

• AutoSum

• VLOOKUP

• COUNT

Answer explanation

The VLOOKUP function can accomplish this goal by helping you look for a specified value by searching for it vertically across the sheet.

How would you write a function for finding the number of cells within this range: A1 through D9?

• =COUNT(A1:D9)

• COUNT(A1:D9)

• =SUM(A1:D9)

• =SUM(A1-D9)

Answer explanation

• COUNT: This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.

When using conditional formatting, what option will change the color of each cell based on its value?

• data bars

• icon sets

• desired cells

• color scales

Answer explanation

Color Scales change the color of each cell based on its value. Each color scale uses a two- or three-color gradient.

If you want to remove conditional formatting from your entire spreadsheet, what must you do?

• select clear rules

• highlight the entire sheet and hit delete

• select clear rules from entire sheet

• highlight the first cell in the spreadsheet and hit delete

Answer explanation

Hover the mouse over Clear Rules, then choose which rules you want to clear. In our example, we'll select Clear Rules from Entire Sheet to remove all conditional formatting from the worksheet.