Online Business
1. What is the underlying value a percentage displayed in a cell (e.g. 25% equals what decimal equivalent?)
.25
maximum formula
=MAX(range)
minimum formula
=MIN(range)
What formula do you use to total up the values in several cells?
=SUM(range)
total formula
=SUM(range)
Average formula
=average(range)
What is a range in Excel?
A collection of cells
What is the fill handle in Excel?
A feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells
What functions do you use to calculate the Minimum, Maximum, Total, and Average of cell values?
Can use the AtuoSum command
Can you Identify the range of cells in an Excel worksheet?
Cell address: In example D6, E7
1. Identify all of the buttons in Excel's font group. What does each one do?
Change font,Change font size, Increase font size, Decrease font size, Text color, Underline, Bold, italic, and borders
How do you properly shut down your computer using Microsoft Windows 10?
Click the start Button, then the power icon, then click shut down
How do you move a file from one folder to another?
Drag it into the new folder while holding down the right mouse button
What feature does Excel have that makes it easier to build functions?
Function Library
What is the order of operations?
PEMDAS (Parentheses Exponents Multiplication/Division Addition/Subtraction)
What is the practice of organizing your digital files?
Placing them in in folders
How do you create formulas that add and multiply cell values (and ensure proper order of operations)?
Put whichever you want first in parentheses
How do you compress a file using Windows 10?
Right click on file, click send to and select compressed (zipped) folder
100.34.78.23 is an example of a/an a. IP Address b. VPN c. Binary Address d. HTTP
a
A ____ in a pie chart identifies the pie slices. a. legend b. data series c. data marker d. data point
a
A ____ is an application with which you can create, edit, and format text documents. a. word processor b. presentation application c. database d. spreadsheet application
a
A(n) ____ is prewritten in Excel 2016 to look at one or more values, perform an operation, and then return a value. a. function b. displayed value c. formula d. underlying value
a
The _____ is the sequence of folders that leads to a file or folder. a. path b. address c. search utility d. finder
a
The default number format for cells is the ______ number format a. general b. accounting number c. currency d. comma style
a
The most commonly used values in a worksheet are ____ a. text values and number values b. date values and time values c. text values and time values d. date values and labels
a
Using AutoFill, what would be the extended series of the initial entry Jan? a. Feb, Mar, Apr b. Kan, Lan, Man, Nan c. Jan1, Jan2, Jan3 d. uar
a
Which of the following is FALSE about Word templates a. The starting point for a blank Word document is called the Standard template. b.A template has a predefined document structure. c. All documents are based on a template. d. A template has a set of defined settings.
a
Which of the following statements is FALSE about a workbook? a. It can contain only one worksheet. b. It contains pages called worksheets. c. The default zoom level is set to 100%. d. It contains one or more worksheets.
a
what is the practice of organizing your digital files? a. file management b. storage capacity c. storage management d. file capacity
a
What is a file?
a digital version of a real-world thing you can interact with on your computer
What is a downloads folder?
a folder in which your computer places downloaded files into
How do you group sheets together in Excel?
a. Select the 1st workbook you want to include b. Press and hold ctrl, select the next workbook you want c. Release ctrl and they are grouped
How can you search for a particular word or phrase in Excel and make changes?
a. search i. From home tab, click the find and select command, then select find from the drop-down menu ii. Find and replace dialog box with appear iii. Enter content you want to find iv. Click find next to find further instances or find all to see every instance of the search term b. Make changes i. From home tab click find and select command, then select replace from drop down menu ii. Find and replace dialog box will appear. Type the text you want to find in the Find What: Field iii. Type the text you want to replace it with in the Replace With: field iv. Click find next v. Click replace to replace individual instances or replace all, will replace every instance of the text vi. Click ok vii. Close find and replace dialogue box
Where do you enter formulas in Excel? What is the correct syntax (what do all formulas begin with?)
all formulas begin with an equal sign, and are entered in the formula bar
If you edit data in a worksheet that is associated with a pie chart ____ a. an error message will display b. the pie slices will be automatically updated c. a new, second pie chart must be created d. the pie slices must be manually updated
b
In Excel 2016, row headings are identified by ____ a. uppercase letters b. numbers c. Roman numerals d. lowercase letters
b
One way to to ensure that your location stays private from websites that you visit is to use a/an __________ a. Secure HTML page b. VPN c. Secure Cookies Protocol d. Internet Security Patch
b
Reputable companies will typically ask you to update your account information in a secure pop up ad. a. true b. false
b
The COUNTIF function has two arguments: ____ a. the range of cells to sum and the criteria b.the range of cells to check and the criteria c.a value as the criteria and an average of a range of cells d.the range of cells to check and the sum of the range
b
The ____ displays the columns and rows that intersect to form the worksheet's cells. a. Quick Access Toolbar b. worksheet grid area c. Name Box d. Formula Bar
b
Use the ________ key to select A5:A8 and D5:D8. a. Alt b. Ctrl c. $ d. Shift
b
What is an Excel table? a. A series of rows and columns that contain related data located on a minimum of two worksheets b. A series of rows and columns that contains related data that can be managed independently from other data in a worksheet c. A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet d. A series of rows and columns that has been assigned a name and can be used in a formula or function
b
When you type data in a cell and press Enter, what cell becomes the active cell? a. the cell above b. The cell below c. The cell to the right d. The insertion point does not move
b
Which of the following is NOT a way to create a formula? a. By typing b. By using a Function button on the status bar c. By using a Function button located on the ribbon d. By using the point and click method
b
Which of the following is NOT true about spreadsheets? a. In a spreadsheet, the intersection of a row and a column is called a cell. b. By using a spreadsheet application, you can create tables to represent data visually. c. Spreadsheets organize data so that it can be sorted, filtered, and rearranged. d. Spreadsheets are quite useful for managing business expenses, payroll, and billing.
b
Which of the following is not a recommended method to prevent your computer from being hacked a.Use 2 factor authentication b.Use the same 14 character password for all of your accounts c.Be careful with how much info you post online d.Update the software on your computer
b
You must select ____ on a worksheet to create a pie chart. a. at least three ranges b.one range of labels and one range of values c. adjacent ranges d.four or more ranges
b
Why do we use zip files?
because they allow us to compress files to make them smaller
By default, documents with the file extension of .rtf open in a. file explorer b. excel c. WordPad or Word D. Microsoft Paint
c
By default, documents with the file extension of .rtf open in ____ a. file explorer b. excel c. wordpad or word d. microsoft paint
c
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? a. The formula returns the text "NO". b. The formula returns the text "NO, RESTART". c.The formula returns the text "RESTART". d. The formula returns the text "DONE".
c
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____ a. A1+B1 is equal to C1 b. none of the above c. A does not equal B d. A is equal to B
c
Line spacing refers to ____ a. the number of lines in a paragraph b. the number of lines that can be read on a computer screen c. the distance between lines of text in a paragraph d. the number of lines on a page
c
Microsoft Word is an example of which type of computer application? a. Database b. Spreadsheet c. Word processing d. Accounting
c
The COUNT function counts the number of cells in a range that ____ a. match a given value b. contain text c. contain a number d. contain a number or text
c
The MEDIAN function finds ____ a. all numbers that correspond to an argument in the function b. the average value in a range of cells c. the middle value in a range of cells d. the one number that corresponds to an argument in the function
c
When using the Freeze Panes feature, what is a pane bounded by? a. The status bar b. A solid red line c. Vertical or horizontal bars d. The ribbon
c
Where does Excel's NOW function retrieve the date and time from? a. The Internet b. The Office 2016 suite c. The computer's calendar and clock d. The Excel program
c
Which of the following is NOT one of the default calculations displayed by AutoCalculate? a. sum b. count c. maximum d. average
c
Which of the following is TRUE about a pie chart? a.It displays data that is arranged in one or more columns or rows or data. b. A pie chart should be your first choice when there are two data series to plot. c.It shows the relationship of each part to a whole. d.A pie chart has a minimum of three data series.
c
What feature does Excel have that automatically shades cells based on a particular rule (e.g the value is >100)
conditional formatting
A ____ enables you to create electronic worksheets composed of rows and columns. a. database b. word processor c. presentation application d. spreadsheet application
d
All Excel formulas begin with a(n) ____ a. #sign b.+ sign c. % sign d. = sign
d
All of the following EXCEPT ____ turns a numbered or bulleted list off a. pressing the Backspace key b.pressing Enter two times c.clicking the Numbering or Bullets button d. pressing the Esc key
d
All of the following are illegal characters in a file name EXCEPT a. / b. ? c. | d. -
d
How do potential spelling and grammar errors display in Word 2016? a. As red and blue bold and italics b. As blue and green wavy underlines c. As red and green bolded text d. As red and blue wavy underlines
d
How do you select an individual word? a. Hold down Ctrl and click the word b. Triple -click the word c. Hold down Shift and click the word d. Double -click the word
d
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ____ a. Data labels b. Data markers c. Data series d. Sparklines
d
To display a large number of categories whose values are close to one another, you should create a ____ chart a. column b. bar c. pie d. either a or b
d
What is an image captured of the active window? a. nameplate b. watermark c. snip d. screenshot
d
Where is the fill handle located? a. on the quick access toolbar b. in the right corner of an active cell c. on the home tab d. in the lower right corner of a selected cell
d
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references? a. COUNTA b. SUM c. AUTOSUM d. COUNT
d
Which of the following is FALSE about worksheet tabs? a. A worksheet tab can be copied. b. You can change the color of worksheet tabs. c. You can rename a tab by double-clicking on it. d. The active worksheet tab displays in red font.
d
Which symbol represents that a cell is an absolute cell reference in a function or formula? a. & b. % c. * d. $
d
Which symbols does Excel use to indicate that a cell is not wide enough to display a formula or function result? a. @ b. - c. * d. #
d
a cell address is also referred to as a(n) a. Value b. active cell c. label d. cell reference
d
subfolders are also called ______ a. Home folders b. specialized foldes c. the file explorer d. children
d
Identify the justification of cells in Excel. Do text values and numerical values have default justification?
default is left bottom
How do you convert an older file of Excel to a newer one?
go to export, change file type
How can you tell if your Excel column is too narrow to display the contents?
if numerical, pound signs will appear
1. What are charts and how do you add one?
it is a Visual representation of data graphically, you can add one by: selecting the cells you want to chart, click the insert tab, click the desired chart command, choose desired chart command
When something is stored in the cloud what does that mean?
it is stored on the internet servers
How to identify the font name and size of a value in a cell in Excel?
on the font tab
How do you change the number of decimal places of a value in a cell in Excel?
on the home tab, in the quick formatting commands
What is the name of the cloud-based storage area that is available when you log into your Microsoft account?
one drive
How do I show a File extension?
open file explorer, click the view tab in file explorer, click the box next to file name extensions to see file extensions
Where might a file be if I accidentally delete it?
recycle bin
How do you extract a file using Windows 10?
right click zip file and select zip all
How can you use the fill handle to create a series of values in Excel?
select cell you want to use, hover over lower right corner where fill handle appears, drag until all desired cells are selected,release mouse to fill
What is the sort button in Excel? What does each one do?
sort button can sort things alphabetically, numerically, by date, or even by custom order
What is a file extension?
three or four letter identifier at the end of a file name, begins with a period, in example .jpg
How do you specify what cells or worksheets you wish to print?
use print pane options
What is a folder?
used to help organize files
When do you use absolute reference in formulas ?
when you want to keep a row and/or column constant
When do you use relative reference in formulas?
whenever you need to repeat the same calculation across multiple rows or columns
Can you convert an Excel file to another type?If so, how? If not, what do you do?
yes by exporting it, steps: i. Click file tab to access backstage view ii. Click export, then select create PDF/XPS iii. Save as will appear, select location, enter a filename, click publish
