100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten
logo-home
Eerder door jou gezocht
Eerder door jou gezocht
logo
MIS112 Questions with All Correct Answers €12,81
In winkelwagen
Snel navigeren naar
Voorbeeld
  2.  
  3. MIS112
  4.  
  5. MIS112

Tentamen (uitwerkingen)

MIS112 Questions with All Correct Answers

 0 keer verkocht
  • Vak
  • MIS112
  • Instelling
  • MIS112

MIS112 Questions with All Correct Answers Which of the following is a way of accessing the "Evaluate Formula" dialog box that helps debug a formula? - Answer-Choose Formula ->Formula Auditing ->Evaluate Formula In Excel in order to avoid incomplete calculation errors and to ensure that f...

[Meer zien]

Voorbeeld 2 van de 14  pagina's

Document informatie

  • 29 augustus 2024
  • 14
  • 2024/2025
  • Tentamen (uitwerkingen)
  • Vragen en antwoorden

Onderwerpen

  • mis112
  • mis112 questions with all correct answers

Geschreven voor

  • MIS112
  • MIS112

Verkoper

avatar-seller
Scholarsstudyguide

Ontvangen beoordelingen

Voorbeeld van de inhoud

MIS112 Questions with All
Correct Answers
Which of the following is a way of accessing the "Evaluate Formula" dialog box that
helps debug a formula? - Answer-Choose Formula ->Formula Auditing ->Evaluate
Formula

In Excel in order to avoid incomplete calculation errors and to ensure that formulas are
fully calculated, you would press _________ . - Answer-Ctrl + Alt + Shift + F9

Please see the attached workbook. Using the formula =B2/C2 what error is displayed? -
Answer-#DIV/0!

Which of the following statements about Trace Precedents are correct? - Answer-All of
the options provided are correct

which key combination can a user press to toggle between formula view and normal
view within excel? - Answer-Ctrl+

when entering / editing an array formula, press ______________ to enter the formula or
excel droes not recognize the formula as an array formula) - Answer-ctrl + shift + enter

What does it mean when excel displays the following error? ##### - Answer-the column
is not wide enough to display contained data or a negative date or time is used

If you want to find the cells on the worksheet that have data validation, which option
would you select? - Answer-Home (tab) -> Editing (group) -> Find & Select -> Data
Validation

which of the following options can be used to quickly remove data validation for a cell? -
Answer-select the cell an open the Data Validation dialog box (data (tab)). on the
settings tab, click Clear All.

please see the attached workbook. in the EmpID table, enter the empID in cell F8 as
12345. given the error message, what will you change in the data validation dialog box
> settings (tab) for 12345 to be a valid entry? - Answer-change the settings to whole
number > less than > 100000

the ________________ command can extract specific pieces of information from cells,
as long as the values are stored consitenty - Answer-flash fill

, what command would you use to import a CSV file? - Answer-choose data --> get
external data --> from text

Please use the attached workbook as an external data source. The workbook has a
table called 'Employee'. When you import data, after selecting all the columns from the
table using the query wizard (Data(tab) -> Get External Data (group) -> From Other
Sources -> From Microsoft Query), how will you filter the records to retrieve those that
have a value lesser than 30000 for 'Salary' column. - Answer-From the Column to Filter
list, select Salary. In the right panel, select 'is less than' from the first drop-down list and
then select '30000.0' from the second drop-down list

Which of the following statements is true?
-A workbook can have at most 3 worksheets.
-A worksheet can have many workbooks.
-A workbook can have many worksheets.
-A worksheet can have at most 3 workbooks. - Answer-A workbook can have many
worksheets.

Which of the following excel tabs is NOT visible in a worksheet by default?
-developer
-review
-home
-insert - Answer-developer

how do you use the transpose feature? - Answer-Select cells A1 through C4 in Sheet1 -
> Copy -> Go to Sheet2 -> Paste -> Transpose

What characters are NOT allowed in sheet names ? - Answer-[]

Which of the following is the keyboard shortcut that creates a new blank workbook in
Excel? - Answer-Ctrl + N

Quick Access Toolbar - Answer-A small customizable toolbar at the top of the screen
with buttons for common commands such as Save and Print.

After pressing "Alt + H" while in an open Excel worksheet, a number of Key Tips are
displayed. Which ribbon tab do these Key Tips relate to? - Answer-home

While comparing two sheets using the "View Side by Side" feature, there is an option
which lets you scroll the two sheets in sync. What is that option called ? - Answer-
Synchronous Scrolling

Would you be able to apply the "watch window" option in multiple sheets at the same
time ? - Answer-Yes

Ribbon - Answer-strip along top of excel worksheet

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Scholarsstudyguide. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €12,81. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis
€12,81
  • (0)
In winkelwagen
Toegevoegd