Skip to main content

BA-113 Business Applications [Aug 25 Syllabus]


 Which of the following is not a way to edit a formula in Excel?

Press Esc.

Which of the following keys is used to toggle through reference types while you enter a formula?

F4

Which of the following options guides you through the process of entering functions?

Insert Function

How does Excel handle the left-aligned text that is too wide for the column in which it appears?

It depends on what is in the next cell to the right.

Which of the following is evaluated last in the Excel order of operations?

Subtraction


Consider the following figure:
The figure shows the worksheet that consists of six columns as Expense, Year 1, Year 2, Year 3, Year 4, and Year 5. The types of expenses are shown as Rent, Remodeling, Legal, Equipment, Supplies, Advertising, Payroll, Miscellaneous, and Totals.
Figure A: The worksheet
What formula will you use to calculate the total expenses of Year 1?

=SUM(B8:B15)

Answer B is correct.In the cell B16, type the formula as =SUM(B8:B15) to calculate the total expenses of Year 1.Answer C is incorrect. In the above scenario, the =AVERAGE(B8:B15) formula is used to calculate the average expenses of Year1.Answer A is incorrect. The =SUM(B8+B15) formula calculates the sum of Rent and Miscellaneous expenses.Answer D is incorrect. The =AVERAGE(B8+B15) formula calculates the average of Rent and Miscellaneous expenses.


Which of the following statements is true about moving and copying the data?

When you move a formula, Excel updates any references they contain relative to the new location of the formula.

An absolute reference in Excel is a pointer to a cell or range of cells and will change when copied to another location in the worksheet.

False

Which sign is typed first to enter a formula into a cell?

Using the Format Painter option will also copy data.


False

Which of the following sets of commands is used to move the data?

Cut and Paste


By default, which alignment is followed when the text is entered in the cell?

Left

Which function is performed by the pointer shown in the following figure?

C the column width

How do you define a range?

By clicking and highlighting the cells you want to be in the range, entering the name in the name box, and then pressing Enter

The AutoSum function will automatically add all the numbers in a range of cells.

True

______ enclose the values on which a function acts.

Parentheses ()

Which shortcut key is used to undo the most recent action?

+Z

When entering a formula in Excel, you need to start with an equal sign.

True

Which character do you use to specify absolute references?

Dollar sign ($)

You can only insert a function from the Formulas tab.

False

Which type of reference is best for referring to a multiplier value that is in one cell on a worksheet for all formulas, no matter where the formulas are?

Absolute

Formulas in Excel will perform the mathematical calculations for you.

True

Which of the following is not one of the possible combinations of reference types?

Mixed: A1$

Excel uses different types of references to refer to cells and ranges either absolutely, or relatively, in terms of their ______.

location

____ are named formulas built into Excel to help you perform all sorts of calculations.

Functions

Which of the following can be accomplished by dragging?

Both moving and copying

Which key do you hold down while copying data by dragging?

Ctrl

How will you specify an absolute reference?

By placing a dollar sign in front of column letters and row numbers

Which of the following is a way in which Excel handles numbers that are too wide for a cell?

Scientific notation

Which of the following features allows you to enter functions like AVERAGE() in a single click?

AutoSum

Which of the following is the name for the values on which a function takes action or performs calculations?

Arguments


Lesson 21 Quiz



Which of the following statements is true about a Column chart

It is useful for showing magnitude in an obvious way.


Which of the following give you control over things like number format, minimum and maximum values, the scale of the chart, tick marks, display units, and more?


Axis Options

Which of the following charts shows how values relate to a whole?

Pie




Consider the following figure:
The figure shows the chart of the Java Tucana Product Sales by Quarter. It also shows the legend on the right side of the chart.
DescribeListen
Figure A: Chart element
What are the steps that can be followed to move the legend below the chart?


Click Add Chart Element > Legend > Bottom.


Which of the following is an element of the chart?

Data point

Which of the following is the correct process to move a chart?

Go to the Chart Tools Design tab and click Move Chart.

What will appear when you click Insert > Charts > Area Chart?

A gallery of line-chart types

Which of the following chart types shows coordinates and is useful for looking at how two related variables are distributed?

Scatter 

How do you update a chart after changing its source data?

By doing nothing because the chart will update automatically


Which of the following chart elements shows the scale for what the chart is measuring?

V axis

Which type of chart is best for showing trends?

Line

How do you create a simple chart in Excel?


By selecting the data, including labels, going to the Insert tab, and then selecting the type of chart you wish to use



Lesson 35 Quiz



Which of the following statements is true about the Get & Transform Data options?

Allow you to create queries that both retrieve data and change it on the fly.

Which of the following is the advantage of using Power Pivot?

Power Pivot provides access to the Data Model through cube functions.

Which format should you use if you want users of database programs to be able to easily import the data and structure of your worksheet?

CSV

Which format should you use if you want the greatest number of users to be able to view your formatted worksheet, regardless of the programs they have on their computers?

PDF

Which of the following is not an example of a cube function?

CUBEFORMULA


Which character distinguishes one piece of data from another in a CSV file?

Comma

Which of the following creates a file that can be viewed in browsers?

Web page

Which of the following is a DAX function that allows you to perform calculations using data from a related table?

RELATED

Which of the following is the data source for which you can create external connections?

Microsoft Access 

Which function allows you to access data within the Power Pivot Data Model directly, without needing a Pivot Table?

Cube

Which of the following groups provides different options to create a connection or a bridge between Excel and data in another source?

Get External Data

























































































































































Comments

Post a Comment

Popular posts from this blog

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in t...
Post a Comment
Read more

GE5093 Design Thinking All Quizzes

  GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00  out of 10.00 ( 80 %) Top of Form Question  1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question  2 Incorrect 0.00 point...
Post a Comment
Read more

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What...
Post a Comment
Read more