MIS 100 REVIEWER

unta sayon ra ang exam huhu

Excel

is a spreadsheet program that allows you to store, organize, and analyze information

Quick Access Toolbar

lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference

Ribbon

contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.

Tell Me

works like a search bar to help you quickly find tools or commands you want to use

Microsoft Account

From here, you can access your Microsoft account information, view your profile, and switch accounts.

Name Box

displays the location, or name, of a selected cell.

Formula Bar

you can enter or edit data, a formula, or a function that will appear in a specific cell.

Column

is a group of cells that runs from the top of the page to the bottom, are identified by letters.

Cell

Each rectangle in a workbook, is the intersection of a row and a column.

Rows

is a group of cells that runs from the left of the page to the right, are identified by numbers.

Workbooks

Excel files are called

Worksheets

Each workbook holds one or more

Worksheet View Options

There are three ways to view a worksheet. Simply click a command to select the desired view.

Zoom Control

Click and drag the slider to use the zoom control. The number to the right of the slider reflects the zoom percentage.

Vertical and Horizontal Scroll Bar

The scroll bars allow you to scroll up and down or side to side. To do this, click and drag the vertical or horizontal scroll bar.

Normal View, Page Layout View, Page Break View

three ways to view a worksheet

Backstage View

gives you various options for saving, opening a file, printing, and sharing your workbooks.

AutoRecover

Excel automatically saves your workbooks to a temporary folder while you are working on them. If you forget to save your changes or if Excel crashes, you can restore the file using this

.xlsx

By default, Excel workbooks are saved in what file type?

Cell Range

A group of cells is known as a

True

True or False: VLOOKUP can search for values in a different worksheet within the same workbook

True

TRUE OR FALSE: VLOOKUP can only look up values vertically in a table

False

TRUE OR FALSE: VLOOKUP can handle multiple criteria for searching in a table

True

TRUE OR FALSE: If the lookup value is not found, VLOOKUP returns an #N/A error

False

TRUE OR FALSE: Excel's IF function can only test for one condition

False

TRUE OR FALSE: The AVERAGE function in Excel calculates the median value in a range of cells

False

TRUE OR FALSE: The COUNT function in Excel counts the number of cells in a range that contain numbers

True

TRUE OR FALSE: The SUMIF function in Excel adds up values in a range based on a given condition

True

TRUE OR FALSE: The CONCATENATE function in Excel can combine text from multiple cells into a single cell

False

TRUE OR FALSE: PivotTables can only summarize data numerically, not handle text or categorical data

True

TRUE OR FALSE: Calculated fields in a PivotTable allow users to create new fields based on calculations performed on existing fields

False

TRUE OR FALSE: PivotTables remove duplicates automatically when summarizing data

True

TRUE OR FALSE: Changes made to the layout of a PivotTable don't affect the original data

False

TRUE OR FALSE: It's impossible to sort data within a PivotTable

True

TRUE OR FALSE: VLOOKUP stands for Vertical Lookup and is used for a value in the leftmost column of a table

PowerPoint

is a presentation program that allows you to create dynamic slide presentations

Normal View, Slide Sorter View, Reading View, Slide Show View

There are four ways to view a presentation

Comments

Reviewers can leave comments on any slide. Click Comments to view comments for the current slide.

Notes

Click Notes to add notes to your current slide. Often called speaker notes, they can help you deliver or prepare for your presentation.

Slide Number Indicator

Here, you can quickly see the total number of slides in your presentation, as well as which slide you are viewing.

Slide Navigation Pane

allows you to view and organize the slides in your presentation

Ruler

is located at the top and to the left of your current slide. It makes it easy to align text and objects on your slide

Slide Pane

Here, you can view and edit the selected slide.

AVERAGE, SUM, SUMIF, COUNT, COUNTA, COUNTIF, CONCATENATE, IF, VLOOKUP

MS EXCEL Common Functions

=AVERAGE(number1,number2,...)

formula for AVERAGE

=SUM(number1,number2,...)

formula for SUM

=SUMIF(range,criteria,sum_range)

formula for SUMIF

=COUNT(value1,value2,...)

formula for COUNT

=COUNTA(value1,value2,...)

formula for COUNTA

=COUNTIF(range,criteria)

formula for COUNTIF

=CONCATENATE(text1,text2,...)

formula for CONCATENATE

=IF(logical_test,value_if_true,value_if_false)

formula of IF

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

formula of VLOOKUP